ESI Invoices

The ESI Invoices function is used to export invoice information based on the selected accounting period The output files can be DBF, ASCII, XML, or CSV formats.

1. Follow the common External System Interface (ESI) overview and instructions found in the ESI menu overview.

2. At the Period field, enter the accounting period for the ESI invoice file.

3. At the Year field, enter the year for the file.

4. A Select A File Type window will display the following options:

• EXIT – Select EXIT to exit and return to the Select A Date Type window.
• DBF Microsoft Foxpro file – Select DBF Microsoft Foxpro file to save the output file in a DBF file format.
• ASCII Delimited Text file – Select ASCII Delimited Text file to save the output file in an ASCII file format.
• XML Extensible Markup Language File – Select XML to save the output file in an XML file format.
• CSV – Microsoft Comma Separated Value File – Select CSV Microsoft Comma Separated Value File to save the file in a CSV file format that can be imported into Microsoft Excel or other data.

Scroll to the appropriate selection and press Enter.

5. A Select A File Name window will display with the following options:

• EXIT – Select EXIT to exit and return to the Select A File Type window.
• ESI Invoices PERIOD – Select ESI Invoices PERIOD to name the file as: ESI Invoices YYYY PP.file extension name selected, where YYYY is the current accounting year and PP is the current accounting period when the file was created.
• ESI Invoices DATE – Select ESI Invoices DATE to save the file as: ESI Invoices YYYY MMDD.file extension name selected where YYYY is the year and MMDD is the date.
• ESI Invoices TIME – Select ESI Invoices TIME to save the file as: ESI Invoices YYYY MMDD hhmmss am/pm.file extension name selected, where YYYY is the year, MMDD is the date, and hhmmss is the time the file was created.

Scroll to the appropriate selection and press Enter.

If the file name and type selected already exist, the following message will display: "Warning: File already exists!!! Continue? No/Yes."

• Select no to return to the Period field.
• Select yes to create a new file with the same name that already exists.

6. The following message will display: "Print report? No/Yes."

• Select no to generate the export file without a printed detail report. You will return to the Period field.
• Select yes to create the file with a printed detail report.

Select the appropriate option.

If you selected yes in Step #6 to print the report, command options will appear allowing you to print or choose from a set of other print options.

The following information will print:

• Ty – The order type
• OR – Sales order
• CR – Credit order
• Invoic – The invoice number
• Order – The sales order number
• Cust – The customer ship-to ID
• Inv Date – The invoice date
• Ct – The sales category for the order line item
• Group – The item class and subclass for the sales order line item
• Item – The item name
• Price – The total invoice selling price per unit
• Qty Ship – The total units shipped and shipping unit of measure
• Cstd – Y = yes, the item has been costed, N = no, the item has not be costed
• Qty Costed – The quantity costed based on the invoicing unit of measure
• Value – The total cost, based on the invoicing unit of measure
• X - Prd – N = credit invoice was posted to the same period as the original invoice, Y = the credit invoice was posted to a different period than the original invoice.
• RT - The Route assigned to the invoice

The following fields will be exported from the system:

Security Required : Receivables - Receivable Reports